create external table jms_dim.dim_tab_exam_subject_list_dt
(
  exam_id             int            comment''
  ,exam_type           string        comment''
  ,exam_title          string        comment''
  ,exam_image          string        comment''
  ,choose_a            string        comment''
  ,choose_b            string        comment''
  ,choose_c            string        comment''
  ,choose_d            string        comment''
  ,answer              string        comment''
  ,analysis            string        comment''
  ,userccde            string        comment''
  ,username            string        comment''
  ,create_time         timestamp     comment''
  ,update_time         timestamp     comment''
  ,create_network_id   int           comment''
  ,create_network_code string        comment''
  ,create_network_name string        comment''
  ,franch_network_id   int           comment''
  ,franch_network_code string        comment''
  ,franch_network_name string        comment''
  ,proxy_network_id    int           comment''
  ,proxy_network_code  string        comment''
  ,proxy_network_name  string        comment''
  ,exam_tag_id         int           comment''
  ,exam_tag_name       string        comment''
  ,use_object          int           comment''
  ,option_type         string        comment'选项类型'
  ,effect_start_time   timestamp     comment'生效开始时间'
  ,effect_end_time     timestamp     comment'生效结束时间'
  ,status              int           comment'状态，0启用 1禁用'
  ,stop_answer_option  string        comment'开放题终止答题选项'
)comment'试题管理试题表'
PARTITIONED BY (`dt` string COMMENT '更新/创建日期 (yyyy-MM-dd)')
stored as parquet
LOCATION
   '/dw/hive/jms_dim.db/external/dim_tab_exam_subject_list_dt'
tblproperties (
      'parquet.column.index.access'= 'true'
)
;